Enquiry_EventLog Tables
The accounts_ServiceUnitEnquiry_EventLog_changelog and accounts_ServiceUnitEnquiry_EventLog_latest tables stores the logs for various events of all the enquiries, including event type, user details and event times.
🔹 Standard Columns​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
document_name | STRING | YES | Firestore document path reference |
document_event_id | STRING | YES | Unique identifier for the document event |
document_timestamp | TIMESTAMP | YES | Timestamp of the document modification/creation |
document_operation | STRING | YES | Type of document operation (e.g., INSERT, UPDATE, DELETE) |
document_id | STRING | YES | Unique document ID in Firestore |
accountId | STRING | YES | ID of the account |
serviceUnitId | STRING | YES | ID of the service unit |
enquiryId | STRING | YES | ID of the enquiry |
🔸 Array Columns​
Array of STRUCT
events​
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
event | STRING | YES | Name/type of the event |
firstname | STRING | YES | First name associated with the event |
label | STRING | YES | Label for the event |
lastname | STRING | YES | Last name associated with the event |
reason | STRING | YES | Reason for the event |
timestamp._seconds | INT64 | YES | Seconds part of the event timestamp |
timestamp._nanoseconds | INT64 | YES | Nanoseconds part of the event timestamp |
fromAPI | BOOL | YES | Whether the event originated from an API enquiry |